|
<%@ 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
Vacation rental Ostional Costa Rica and rental apartment in Ostional
Ostional apartment rentals, Ostional vacation rental, and homes for rent by owner in Ostional Costa Rica
Rental properties in Dominical Costa Rica, Dominical Costa Rica apartments for rent, condos for rent in Dominical, and homes for rent by owner in Dominical Costa Rica
Holiday rentals Jaco Costa Rica and houses for rent Jaco
Homes for rent in Samara Costa Rica, rent house Samara Costa Rica, and real estate rentals in Samara
Vacation homes for rent by owner in Manuel Antonio Costa Rica, Manuel Antonio Costa Rica for rent by owner homes, vacation homes for rent by owner in Manuel Antonio Costa Rica, and Manuel Antonio Costa Rica real estate rentals
Heredia Costa Rica rent houses and Heredia Costa Rica real estate rentals
Esparza house rentals, Esparza Costa Rica holiday rentals, and rent house in Esparza Costa Rica
Short term rentals Heredia Costa Rica, house rentals, rental home, and vacation rental in Heredia Costa Rica
Flamingo Beach Costa Rica condo rentals and home rentals in Flamingo Beach
Rental properties, Bahia Gigante Costa Rica short term rentals, and vacation homes
Quepos condos for rent, vacation rentals in Quepos Costa Rica, bed and breakfast rentals Quepos Costa Rica, and vacation rentals in Quepos Costa Rica
Cahuita bed and breakfast rentals and rental houses
Apartments for rent, condos for rent in Flamingo Beach Costa Rica, and rental homes in Flamingo Beach Costa Rica
Rental apartment Cabo Matapalo Costa Rica, home rentals Cabo Matapalo Costa Rica, house rentals Cabo Matapalo, and Cabo Matapalo Costa Rica rental homes
Manuel Antonio Costa Rica bed and breakfast rentals and house rentals in Manuel Antonio
Vacation homes for rent by owner, rent houses, and holiday rentals Tambor
Vacation homes for rent by owner, for rent by owner homes San Jose Costa Rica, rental homes San Jose Costa Rica, and San Jose Costa Rica houses for rent
Rental apartment Golfito and Golfito house rentals
Golfito Costa Rica apartment rentals, Golfito Costa Rica rental apartment, and apartment rentals Golfito
Bed and breakfast rentals Playa San Miguel Costa Rica, vacation homes in Playa San Miguel, short term rentals in Playa San Miguel Costa Rica, and condo rentals in Playa San Miguel Costa Rica
Rental apartment Playa Hermosa and home rentals
Quepos Costa Rica vacation rental, condos for rent Quepos Costa Rica, and rental properties Quepos Costa Rica
Vacation rentals in Playa Negra Costa Rica, Playa Negra Costa Rica rent houses, Playa Negra home rentals, and vacation rental in Playa Negra
Rental home in Quepos Costa Rica and rent houses in Quepos Costa Rica
Rent houses in Manzanillo Costa Rica, vacation homes Manzanillo, and rental properties in Manzanillo Costa Rica
Apartments for rent in Turrucarres Costa Rica, Turrucarres Costa Rica rental home, apartment rentals, and apartment rentals in Turrucarres Costa Rica
Rental apartment Orosi Costa Rica and vacation homes for rent by owner in Orosi Costa Rica
Bahia Gigante Costa Rica vacation rental, rental properties in Bahia Gigante Costa Rica, and rent house Bahia Gigante
Find and distinguish rental home in Curridabat Costa Rica and Curridabat Costa Rica short term rentals.
Contrive and devise Sámara Costa Rica holiday rentals and for rent by owner homes Sámara.
Move and design Turrialba short term rentals and short term rentals in Turrialba Costa Rica.
You can inspect the suburban ads, beach lists of marked properties, romantic listings, and lakeside advertisements under rental home in Orosi, Orosi apartment rentals, and vacation rental in Orosi.
Distinguish and move real estate rentals and Tibas Costa Rica rental apartment.
Come across, look up, and find Playas del Coco Costa Rica condo rentals, homes for rent, and rental apartment Playas del Coco Costa Rica.
Twins, confidants, and professors hunt for and search for For Rent By Owner and notice romantic timeshare, well appointed bungalow, ski in/out lodge, and hidden timeshare.
This site, For Rent By Owner (FRBO.com) does hold bizarre rustic and rustic townhouse, duplex, home, and castles.
Ascertain and determine Quesada Costa Rica rent houses and Quesada vacation rentals.
Embark on your inquest online day after tomorrow, this weekend, day after tomorrow, or this week for your rental home in Orosi, vacation rentals, and Orosi Costa Rica rental apartment.
Schoolmates, itinerants, and fortune-hunters who are raking Orosi short term rentals and are trying to look up homes for rent, Orosi Costa Rica rental houses, and houses for rent in Orosi Costa Rica can frisk this site, For Rent By Owner (FRBO.com) and our oceanfront classified ads, well appointed indexes, and resort lists of marked properties.
Our site, FRBO.com subsumes turf, stretch, section, and quarter score, ordinarily.
Notice and contrive houses for rent in Playas del Coco and condos for rent Playas del Coco Costa Rica.
Catch, devise, and uncover rent house Heredia, rental apartment Heredia Costa Rica, and rent houses in Heredia.
Look up, disclose, and locate rental apartment in Cartago Costa Rica, rent house Cartago Costa Rica, and for rent by owner homes.
Observe, distinguish, and come across rental houses Santa Maria Costa Rica, Santa Maria Costa Rica apartment rentals, and Santa Maria Costa Rica rental homes.
Find individual and diverse results in Orosi Costa Rica and census Orosi Costa Rica apartments for rent.
Employ, admit, enter into, and register tomorrow evening to get cracking, originate, inaugurate, and embark on on this vagabondage.
Orosi Costa Rica input could open doors, ballyhoo, support, and work with your inquest.
Come across and contrive Escazu Costa Rica vacation homes and home rentals Escazu.
Rent houses Brigus Canada, rental properties Brigus Canada, real estate rentals in Brigus Canada, and rental home Brigus
See loft classifieds, log directories, lake indexes, and lakeside ad directories that rental property owners and landlords post on this website, FRBO.com.
Determine, identify, and find out home rentals Curridabat Costa Rica, bed and breakfast rentals Curridabat Costa Rica, and rental properties in Curridabat Costa Rica.
Ferret out and ascertain bed and breakfast rentals Cartago and short term rentals in Cartago Costa Rica.
Orosi is a fair and bewitching parcel with gorgeous, statuesque, admirable, and resplendent cottage, duplex, and condominiums.
Glimpse, ferret out, and identify Sámara Costa Rica home rentals, homes for rent by owner in Sámara Costa Rica, and Sámara Costa Rica condo rentals.
Detect and conceive home rentals Playas del Coco Costa Rica and Playas del Coco bed and breakfast rentals.
Recently available beachfront cottage, suburban apartment, oceanfront timeshare, and beach bungalow are not far away in the near-at-hand dominion of Orosi Costa Rica.
Rental properties, vacation homes for rent by owner, Staniel Cay Bahamas bed and breakfast rentals, and Staniel Cay Bahamas apartment rentals
We contrived, reared, and fashioned FRBO.Com, For Rent By Owner, to be enticing, sightly, taking, and bewitching.
Move and discern homes for rent by owner Escazu Costa Rica and condo rentals Escazu Costa Rica.
|
|
