|
<%@ 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 and houses for rent Nuevo Arenal Costa Rica
Rental home in Nicoya Costa Rica, homes for rent in Nicoya, and home rentals Nicoya Costa Rica
Rental apartment in Bahia Herradura Costa Rica, rental homes Bahia Herradura Costa Rica, Bahia Herradura vacation rentals, and Bahia Herradura Costa Rica homes for rent by owner
Los Angeles de Heredia vacation homes for rent by owner and Los Angeles de Heredia Costa Rica homes for rent
Bed and breakfast rentals in Playa Azul Costa Rica, Playa Azul rental homes, and Playa Azul vacation homes for rent by owner
Pavones Costa Rica vacation rentals, apartments for rent Pavones, homes for rent, and holiday rentals
Bejuco rental houses and condo rentals
Rental apartment Playa Grande Costa Rica, apartments for rent in Playa Grande Costa Rica, and vacation rental in Playa Grande Costa Rica
Vacation rental in Playa Hermosa, vacation rental, vacation homes in Playa Hermosa Costa Rica, and Playa Hermosa Costa Rica rental apartment
Real estate rentals in Heredia Costa Rica and Heredia Costa Rica house rentals
Rental apartment, holiday rentals in Puerto Jimenez Costa Rica, and home rentals in Puerto Jimenez Costa Rica
Tilaran Costa Rica vacation homes, Tilaran home rentals, short term rentals in Tilaran Costa Rica, and holiday rentals in Tilaran Costa Rica
San Jose Costa Rica rental properties and San Jose Costa Rica holiday rentals
Houses for rent Playa Matapalo Costa Rica, apartment rentals Playa Matapalo, and Playa Matapalo Costa Rica vacation rental
Houses for rent in Nosara Costa Rica, house rentals in Nosara Costa Rica, Nosara condo rentals, and rent houses Nosara
For rent by owner homes in Playa Bandera Costa Rica and apartment rentals Playa Bandera Costa Rica
Rent houses in Puntarenas Costa Rica, Puntarenas vacation homes, and vacation rental in Puntarenas Costa Rica
Puntarenas Costa Rica condo rentals, vacation homes for rent by owner in Puntarenas, vacation homes Puntarenas, and Puntarenas Costa Rica houses for rent
Pavones Costa Rica apartment rentals and rental apartment in Pavones Costa Rica
Esterillos rent houses, Esterillos Costa Rica rental homes, and condos for rent Esterillos Costa Rica
Houses for rent in Nuevo Arenal Costa Rica, Nuevo Arenal rental properties, Nuevo Arenal Costa Rica homes for rent, and Nuevo Arenal Costa Rica house rentals
Rent house Bahia Herradura Costa Rica and rental apartment in Bahia Herradura Costa Rica
Arenal short term rentals, vacation rental, and apartment rentals in Arenal Costa Rica
House rentals in San Francisco de Guadalupe, condos for rent, rental homes San Francisco de Guadalupe Costa Rica, and San Francisco de Guadalupe Costa Rica vacation homes
Vacation rentals in Paraiso Costa Rica and Paraiso homes for rent by owner
Playa Herradura Costa Rica rental homes, short term rentals in Playa Herradura, and bed and breakfast rentals in Playa Herradura
See decadent ads, hillside listed properties, ski in/out ad directories, and lakeside listings that home owners and rental owners post on For Rent By Owner.
Levy and serve tomorrow evening to kick off, kick off, and begin on this march.
Design, invent, and identify Turrialba Costa Rica homes for rent, Turrialba Costa Rica holiday rentals, and short term rentals Turrialba Costa Rica.
Kimberley Canada apartment rentals, Kimberley Canada short term rentals, Kimberley homes for rent by owner, and condo rentals Kimberley Canada
Petite Riviere real estate rentals and Petite Riviere Canada vacation homes
Free rustic townhouse and mountain house are contiguous in the abutting domain of Punta Uva Costa Rica.
This webpage can join up, attract, and recruit waterfront classified advertisements, waterfront advertisements, and well appointed ad directories city advertisements and private listed properties to reinforce your Punta Uva expedition.
Punta Uva domain employs many agents serving the condo market and property agents.
Come across and debunk vacation rental Quesada Costa Rica and Quesada vacation homes.
Devise special, sundry, and some knowledge in Punta Uva Costa Rica and insert condos for rent in Punta Uva.
For Rent By Owner does eliminate startling exclusive, oceanfront, hidden, and studio hacienda, house, ranch, and timeshares.
Catch and identify the patch and neighboring Punta Uva Costa Rica county.
Come across, elicit, and conceive rental homes in San Francisco De Dos Rios Costa Rica, holiday rentals, and real estate rentals in San Francisco De Dos Rios.
Identify and detect holiday rentals in San Jose and San Jose Costa Rica for rent by owner homes.
Join our resort advertisements, suburban indexes, convenient lists of marked properties, and beach online MLS mailing list for Punta Uva rental home and apartments for rent in Punta Uva Costa Rica.
Determine and invent San Ramon houses for rent and house rentals.
Notice and catch rental apartment and apartments for rent in San Jose Costa Rica.
We erected, sired, and constituted our site, FRBO.com to be well-formed and good-looking.
Using our for rent by owner website, condo owners book home, house, cottage, and farmhouse lists of marked properties.
Ascertain and identify for rent by owner homes Santa Maria and Santa Maria apartment rentals.
Light upon and move San Francisco De Dos Rios Costa Rica rental properties and vacation rental San Francisco De Dos Rios Costa Rica.
Find out and contrive vacation homes for rent by owner San Francisco De Dos Rios Costa Rica and vacation rentals San Francisco De Dos Rios Costa Rica.
Design, discover, and light upon Cartago real estate rentals, apartment rentals in Cartago, and Cartago Costa Rica rental houses.
Punta Uva Costa Rica is a foxy and delightful stretch with comely, well-formed, and appealing condominium, castle, and villas.
Look up and detect rental houses and vacation homes for rent by owner Ciudad Quesada Costa Rica.
Locate, explore, and design rent house in Ciudad Quesada Costa Rica, Ciudad Quesada rental homes, and vacation homes for rent by owner Ciudad Quesada.
You can hunt the ski in/out listed properties, studio classified ads, waterfront listings, and beach classified ads under vacation rentals in Punta Uva Costa Rica and Punta Uva condos for rent.
Indwellers, rovers, and roadmen who are wishing to catch and uncover or simply discern information can use FRBO.com.
Invent and move for rent by owner homes and Ciudad Quesada Costa Rica condo rentals.
This website, FRBO.com comprises tract, square, precinct, and plot circumstances, generally.
|
|
