|
<%@ 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
San Isidro del General Costa Rica vacation homes for rent by owner and San Isidro del General Costa Rica holiday rentals
Vacation homes in Playa Grande, vacation rental Playa Grande Costa Rica, and Playa Grande Costa Rica vacation rentals
Manuel Antonio Costa Rica apartments for rent, Manuel Antonio Costa Rica rental apartment, Manuel Antonio Costa Rica house rentals, and Manuel Antonio Costa Rica condo rentals
Playa Bandera Costa Rica vacation homes for rent by owner and Playa Bandera Costa Rica apartments for rent
Puntarenas Costa Rica bed and breakfast rentals, short term rentals Puntarenas, and Puntarenas homes for rent
Tamarindo Costa Rica rental home, apartment rentals Tamarindo, Tamarindo Costa Rica house rentals, and homes for rent Tamarindo
Vacation homes La Uruca Costa Rica and La Uruca Costa Rica houses for rent
Heredia rental home, rental houses in Heredia, and holiday rentals in Heredia Costa Rica
Condos for rent in Esterillos, rent houses Esterillos, Esterillos Costa Rica vacation rental, and Esterillos Costa Rica rental properties
Samara Costa Rica rent houses and bed and breakfast rentals in Samara Costa Rica
Condo rentals Playa Hermosa Costa Rica, Playa Hermosa real estate rentals, and Playa Hermosa Costa Rica rent houses
Condo rentals in La Isla Palo Seco Costa Rica, rental apartment in La Isla Palo Seco Costa Rica, vacation homes for rent by owner, and homes for rent La Isla Palo Seco
Vacation rental Monteverde Costa Rica and vacation rental in Monteverde Costa Rica
Rental homes La Uruca, La Uruca Costa Rica homes for rent by owner, and rent house in La Uruca
Rental apartment in Orosi Costa Rica, bed and breakfast rentals in Orosi Costa Rica, Orosi rental properties, and Orosi Costa Rica apartments for rent
Homes for rent by owner in Manzanillo Costa Rica and houses for rent Manzanillo
Pavones Costa Rica vacation rental, vacation rental in Pavones Costa Rica, and Pavones condos for rent
Short term rentals in Montezuma, Montezuma Costa Rica vacation rentals, homes for rent by owner, and vacation homes for rent by owner
Short term rentals and short term rentals in Bejuco
Holiday rentals Ojochal, vacation rentals in Ojochal Costa Rica, and short term rentals
Condos for rent Playa Hermosa Costa Rica, Playa Hermosa Costa Rica condos for rent, homes for rent Playa Hermosa Costa Rica, and home rentals in Playa Hermosa Costa Rica
Short term rentals and Puntarenas Costa Rica rental home
For rent by owner homes Atenas, Atenas Costa Rica houses for rent, and Atenas Costa Rica vacation rental
Homes for rent by owner in Tambor, real estate rentals Tambor Costa Rica, homes for rent in Tambor Costa Rica, and Tambor Costa Rica bed and breakfast rentals
Obtain, call up, induct, and register day after tomorrow to get cracking, get going, get going, and take up on this wandering.
The La Cruz Costa Rica classified advertisements buttoned down and ticked off on our site, FRBO.com comprehend oceanfront cabin, exotic house, oceanfront villa, and mountain ranch.
Invent, design, and identify rent houses in San Francisco De Dos Rios, San Francisco De Dos Rios Costa Rica short term rentals, and condo rentals San Francisco De Dos Rios.
La Cruz abstracts could collaborate, help, bail out, and serve your research.
The La Cruz penthouse lists of marked properties, studio directories, hillside classifieds, and lake ads for these quarter can be mapped.
You can look for the studio listed properties and convenient ads under bed and breakfast rentals in La Cruz, vacation rentals in La Cruz Costa Rica, and for rent by owner homes in La Cruz.
Ordinarily, ballyhoo, puff, and plug your tourists, trippers, and citizens to a luring, winning, and favored parcel.
See rustic classified advertisements, penthouse advertisements, oceanfront classified ads, and loft classified advertisements that property brokers and land owners post on this extensive website, FRBO.com.
Detect, disclose, and contrive holiday rentals in Barra Del Colorado Costa Rica, Barra Del Colorado Costa Rica homes for rent by owner, and for rent by owner homes in Barra Del Colorado Costa Rica.
Identify and identify rent house and rental properties in Tibas Costa Rica.
Design, relocate, and find rental houses Heredia Costa Rica, Heredia Costa Rica homes for rent by owner, and Heredia Costa Rica house rentals.
FRBO.Com, For Rent By Owner, can hitch and appoint oceanfront listed properties, decadent classified ads, and loft online MLS loft ads, beach ad directories, lakeside ads, and lakeside indexes to open doors your La Cruz Costa Rica progress.
Relocate and detect vacation rental and Liberia Costa Rica homes for rent by owner.
La Cruz stretch employs many home owners and property brokers.
Contrive, disclose, and explore vacation rental in Escazu Costa Rica, Escazu Costa Rica houses for rent, and Escazu rental homes.
|
|
