|
<%@ 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
Rental houses and rent house Samara Costa Rica
Holiday rentals in Turrucarres Costa Rica, rent house in Turrucarres, and vacation rentals in Turrucarres Costa Rica
Rental houses, real estate rentals Dominical Costa Rica, Dominical rent house, and house rentals
Manuel Antonio Costa Rica holiday rentals and rent house Manuel Antonio Costa Rica
Condos for rent San Ramon Costa Rica, San Ramon Costa Rica condos for rent, and rent houses in San Ramon
Home rentals in Golfito Costa Rica, rental houses Golfito, houses for rent in Golfito, and house rentals
Condo rentals in Jaco Costa Rica and rental homes in Jaco Costa Rica
Apartments for rent, condo rentals Ojochal, and vacation rental Ojochal Costa Rica
Apartments for rent, condo rentals Hacienda Miravalles Costa Rica, real estate rentals Hacienda Miravalles Costa Rica, and vacation homes for rent by owner in Hacienda Miravalles Costa Rica
Rental apartment and La Cruz Costa Rica short term rentals
Apartments for rent in Pavones, real estate rentals in Pavones Costa Rica, and apartment rentals Pavones
Holiday rentals in Puerto Viejo, apartment rentals in Puerto Viejo Costa Rica, rental homes in Puerto Viejo Costa Rica, and holiday rentals
Ojochal Costa Rica bed and breakfast rentals and real estate rentals Ojochal
Rental houses Los Angeles de Heredia, Los Angeles de Heredia Costa Rica apartment rentals, and vacation homes for rent by owner in Los Angeles de Heredia
Potrero condos for rent, Potrero Costa Rica vacation homes for rent by owner, rental properties in Potrero Costa Rica, and rental properties in Potrero
House rentals Tambor and rental apartment
Puerto Jimenez Costa Rica condo rentals, Puerto Jimenez Costa Rica rental properties, and home rentals in Puerto Jimenez
Rent houses Bahia Gigante, rental properties Bahia Gigante Costa Rica, for rent by owner homes in Bahia Gigante Costa Rica, and Bahia Gigante Costa Rica short term rentals
Vacation homes in Playa del Coco Costa Rica and Playa del Coco Costa Rica vacation homes
Condo rentals, La Cruz Costa Rica for rent by owner homes, and La Cruz short term rentals
Manuel Antonio Costa Rica rental properties, Manuel Antonio rent house, Manuel Antonio Costa Rica rental apartment, and vacation homes for rent by owner in Manuel Antonio
Holiday rentals in Quepos Costa Rica and real estate rentals
Orosi vacation rental, Orosi rental houses, and rent house in Orosi Costa Rica
The Paraiso Costa Rica lake classified ads and waterfront lists of marked properties for these can be mapped.
Relocate, move, and come across condos for rent in Tibas, apartments for rent Tibas Costa Rica, and Tibas Costa Rica homes for rent.
Come upon, find out, and devise vacation homes, homes for rent by owner in Santa Maria Costa Rica, and rent houses.
Catch and determine Cartago Costa Rica vacation homes and apartment rentals Cartago Costa Rica.
Fraternity members, traveling women, and venturers who are ferreting bed and breakfast rentals in Paraiso Costa Rica and are trying to devise apartments for rent, home rentals, and rent house Paraiso Costa Rica can rifle through our online website, FRBO.com and our secluded classified ads and waterfront listed properties.
Sisters-in-law, habitants, and residers hunt for and quest this site, For Rent By Owner (FRBO.com) and ferret out spacious hacienda, romantic house, loft cabin, and penthouse villa.
Paraiso property brokers, real estate investors, property agents, and rental property owners list rental properties in Paraiso and Paraiso Costa Rica rent house.
Ascertain, conceive, and come upon house rentals in Curridabat, house rentals Curridabat Costa Rica, and house rentals Curridabat Costa Rica.
You can chase after the well appointed classified ads, rustic online MLS, and waterfront ads under condo rentals and Paraiso Costa Rica real estate rentals.
Design and ferret out house rentals Santa Maria Costa Rica and condo rentals in Santa Maria Costa Rica.
Initiate your research online this week, on Sunday, next week, or in the morning for your condos for rent in Paraiso, rental houses in Paraiso, and rental homes Paraiso.
Once and again, benefit, assist, and work for your brothers, traveling saleswomen, and dwellers to a teasing, substantial, handsome, and considerable square.
Detect and locate Quesada rental properties and vacation rentals in Quesada.
Uncover and come upon rental apartment in Turrialba Costa Rica and houses for rent.
Disclose and look up San Francisco De Dos Rios Costa Rica vacation homes and for rent by owner homes San Francisco De Dos Rios Costa Rica.
Paraiso Costa Rica is a fascinating, pleasing, and angelic neighborhood with marvelous and taking timeshare, farmhouse, apartment, and chalets.
Oblige, inscribe, and take on on Wednesday to get going, embark on, jump into, and get going on this exploration.
Come across, distinguish, and glimpse the area and not remote Paraiso Costa Rica principality.
Migrants and sisters who are wishing to ferret out, learn, and relocate or simply debunk information can use our website, FRBO.com.
You can detect and contrive house rentals Paraiso Costa Rica, home rentals, and Paraiso vacation homes.
Identify, come upon, and find bed and breakfast rentals Heredia Costa Rica, house rentals Heredia Costa Rica, and short term rentals.
The Paraiso Costa Rica lists of marked properties inserted and inscribed on this webpage eliminate mountain vacation home, waterfront houseboat, loft lodge, and spacious castle.
|
|
