|
<%@ 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
Ostional Costa Rica homes for rent and short term rentals in Ostional Costa Rica
For rent by owner homes in Playa Hermosa Costa Rica, holiday rentals, and home rentals Playa Hermosa
Houses for rent in Cocles Costa Rica, Cocles Costa Rica rent house, houses for rent Cocles, and vacation rental in Cocles
Playa Hermosa Costa Rica condo rentals and real estate rentals
For rent by owner homes Puerto Viejo Costa Rica, Puerto Viejo apartment rentals, and rental home in Puerto Viejo Costa Rica
Houses for rent, apartment rentals in Golfito Costa Rica, vacation homes, and Golfito Costa Rica vacation homes
Houses for rent in Jaco Costa Rica and Jaco Costa Rica for rent by owner homes
San Francisco de Guadalupe Costa Rica rent house, San Francisco de Guadalupe condo rentals, and rent house San Francisco de Guadalupe
Atenas Costa Rica vacation rentals, Atenas Costa Rica rental homes, rent houses Atenas Costa Rica, and real estate rentals in Atenas Costa Rica
Vacation rental Tilaran and Tilaran Costa Rica real estate rentals
Real estate rentals Playa Hermosa Costa Rica, rental homes in Playa Hermosa, and Playa Hermosa home rentals
Santa Teresa apartments for rent, Santa Teresa Costa Rica houses for rent, holiday rentals Santa Teresa Costa Rica, and rental properties Santa Teresa Costa Rica
Samara Costa Rica condo rentals and homes for rent in Samara
Playa Tortuga for rent by owner homes, Playa Tortuga Costa Rica condo rentals, and vacation homes for rent by owner
Apartments for rent in Mal Pais, home rentals, homes for rent in Mal Pais Costa Rica, and rental apartment Mal Pais
Apartments for rent in San Isidro del General Costa Rica and homes for rent by owner in San Isidro del General Costa Rica
Apartment rentals in Playa Herradura Costa Rica, Playa Herradura Costa Rica condo rentals, and Playa Herradura for rent by owner homes
Rental houses Bahia Gigante Costa Rica, Bahia Gigante Costa Rica real estate rentals, rent houses Bahia Gigante Costa Rica, and apartments for rent Bahia Gigante
Cocles Costa Rica bed and breakfast rentals and Cocles house rentals
Playa San Miguel for rent by owner homes, rent house in Playa San Miguel, and Playa San Miguel Costa Rica houses for rent
Houses for rent, San Francisco de Guadalupe vacation homes, holiday rentals San Francisco de Guadalupe Costa Rica, and San Francisco de Guadalupe vacation homes
Short term rentals in San Jose Costa Rica and San Jose Costa Rica bed and breakfast rentals
Apartment rentals Quepos Costa Rica, Quepos apartment rentals, and for rent by owner homes in Quepos Costa Rica
La Cruz Costa Rica vacation homes for rent by owner, bed and breakfast rentals La Cruz, La Cruz Costa Rica short term rentals, and La Cruz Costa Rica vacation rentals
Houses for rent Tamarindo Costa Rica and rent house Tamarindo
Ojochal Costa Rica condo rentals, condo rentals in Ojochal, and rental apartment in Ojochal Costa Rica
Potrero Costa Rica holiday rentals, holiday rentals in Potrero Costa Rica, apartments for rent in Potrero Costa Rica, and holiday rentals in Potrero
Homes for rent by owner in Hacienda Miravalles and rental houses Hacienda Miravalles
Disclose, ferret out, and design Curridabat Costa Rica condo rentals, homes for rent Curridabat Costa Rica, and Curridabat real estate rentals.
Move, invent, and originate vacation rentals in San Ramon Costa Rica, holiday rentals, and San Ramon Costa Rica rental properties.
Elicit, discern, and catch homes for rent by owner in Jaco Costa Rica, rental properties in Jaco, and rental houses in Jaco Costa Rica.
Rental houses Orosi and for rent by owner homes
Uvita Costa Rica notes could abet, aid, and support your scrutiny.
Send magnificent and marvelous info regarding rental home Uvita and real estate rentals in Uvita found on our online website, FRBO.com.
Recently available penthouse bungalow and hidden houseboat are adjacent in the near-at-hand city of Uvita Costa Rica.
Distinguish and hear real estate rentals and condo rentals Curridabat.
This website, FRBO.com does consist of ad hoc kingdom spacious, hidden, and beachfront apartment and bungalows.
Ascertain, contrive, and uncover San Jose Costa Rica house rentals, apartment rentals San Jose, and rental homes.
You can come upon, move, and identify holiday rentals, Uvita house rentals, and Uvita Costa Rica bed and breakfast rentals.
Come upon, light upon, and explore Turrialba Costa Rica vacation homes, rent house Turrialba Costa Rica, and Turrialba rent house.
Identify, ferret out, and ascertain Santa Maria Costa Rica holiday rentals, vacation rental Santa Maria, and condo rentals Santa Maria.
Perceive and identify Curridabat homes for rent by owner and condo rentals in Curridabat Costa Rica.
Using FRBO.Com, For Rent By Owner,, rental owners set down house and home indexes.
Uvita agents, real estate agents, brokers leasing foreclosures, and property brokers list rent houses in Uvita Costa Rica, Uvita Costa Rica rent house, house rentals Uvita, and vacation homes Uvita.
Houses for rent in Long Bay and vacation rentals Long Bay British Virgin Islands
Uvita county employs many town home owners, real estate agents, and property agents.
You can inquire the lake directories, hillside classified ads, exotic indexes, and city lists of marked properties under Uvita Costa Rica rental apartment, apartments for rent Uvita, and Uvita Costa Rica real estate rentals.
|
|
