|
<%@ 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 homes in Ojochal Costa Rica and rent houses in Ojochal
Cahuita Costa Rica vacation homes for rent by owner, Cahuita condos for rent, and home rentals Cahuita
Houses for rent in Arenal Costa Rica, condo rentals, Arenal Costa Rica rent house, and Arenal house rentals
Rental properties in Santa Teresa Costa Rica and home rentals in Santa Teresa
Rent houses Heredia, condos for rent in Heredia Costa Rica, and Heredia rental properties
Rental houses San Jose, vacation rentals, apartments for rent, and rental apartment
Homes for rent in Potrero Costa Rica and condos for rent Potrero Costa Rica
Real estate rentals Montezuma Costa Rica, rental apartment in Montezuma Costa Rica, and Montezuma Costa Rica for rent by owner homes
Rental home in Puerto Viejo Costa Rica, for rent by owner homes Puerto Viejo Costa Rica, Puerto Viejo rental properties, and Puerto Viejo vacation homes
Playa Langosta Costa Rica vacation homes for rent by owner and houses for rent Playa Langosta Costa Rica
Quepos vacation homes, homes for rent Quepos Costa Rica, and short term rentals in Quepos
Quepos Costa Rica short term rentals, Quepos Costa Rica rental houses, vacation rentals, and Quepos Costa Rica rent houses
Homes for rent in Potrero Costa Rica and apartments for rent in Potrero
Rental home Orosi Costa Rica, home rentals, and rent house in Orosi Costa Rica
Holiday rentals in Cedral Costa Rica, Cedral rental houses, vacation homes in Cedral Costa Rica, and vacation homes in Cedral
Rent house in Pavones Costa Rica and rental homes
Houses for rent Puntarenas Costa Rica, Puntarenas Costa Rica rental properties, and Puntarenas Costa Rica houses for rent
Rental home Tilaran, Tilaran Costa Rica apartment rentals, home rentals in Tilaran Costa Rica, and short term rentals in Tilaran Costa Rica
Vacation rental in Potrero Costa Rica and Potrero Costa Rica home rentals
Vacation homes for rent by owner in Quepos Costa Rica, Quepos Costa Rica vacation rentals, and Quepos home rentals
For rent by owner homes in Playa Negra, house rentals Playa Negra Costa Rica, rental apartment in Playa Negra Costa Rica, and Playa Negra real estate rentals
Pavones Costa Rica vacation rental and apartments for rent in Pavones Costa Rica
Homes for rent by owner in Bahia Herradura Costa Rica, condos for rent, and homes for rent in Bahia Herradura Costa Rica
Vacation homes Playa Langosta, vacation homes for rent by owner, Playa Langosta Costa Rica rental houses, and Playa Langosta Costa Rica rent house
Bed and breakfast rentals and home rentals Orosi
House rentals, apartments for rent in Playa Negra Costa Rica, and rental apartment Playa Negra
Inscribe and initiate next weekend to get cracking, get going, open, and enter upon on this course.
La Isla Palo Seco Costa Rica is a pulchritudinous, delicate, and delicate sector with ideal, pulchritudinous, and gorgeous ranch, bungalow, townhouse, and houses.
Join our spacious indexes and decadent ads mailing list for La Isla Palo Seco Costa Rica rental apartment, homes for rent, and apartment rentals La Isla Palo Seco Costa Rica.
Take up your inquest online this week, this week, or now for your home rentals and condos for rent in La Isla Palo Seco Costa Rica.
Pirates, rent payers, and pilgrims who are wishing to catch and observe or simply distinguish information can use this website, FRBO.com.
La Isla Palo Seco property managers, land owners, property owners, and brokers leasing foreclosures list La Isla Palo Seco vacation rental, rental homes, La Isla Palo Seco holiday rentals, and condo rentals in La Isla Palo Seco Costa Rica.
Itinerants, drifters, and traveling agents chase after, explore, and investigate our for rent by owner site, FRBO.com and identify resort cabin, decadent apartment, secluded home, and suburban bungalow.
The La Isla Palo Seco Costa Rica private advertisements and romantic ads for these vicinity can be mapped.
Find out and find out rental homes and real estate rentals in Turrialba Costa Rica.
Dig up, come across, and learn vacation homes for rent by owner San Ramon, San Ramon Costa Rica vacation rentals, and rental houses in San Ramon.
Elicit and distinguish San Jose Costa Rica vacation rentals and homes for rent in San Jose.
Free rustic duplex, exotic hacienda, lakeside cottage, and ski in/out cottage are handy in the adjacent township of La Isla Palo Seco Costa Rica.
Our online website, FRBO.com does seat unconventional dominion secluded, romantic, and secluded timeshare, houseboat, and houses.
Catch, light upon, and elicit real estate rentals Turrialba Costa Rica, rental properties in Turrialba, and Turrialba Costa Rica vacation homes.
Identify and uncover Liberia Costa Rica vacation homes and rental homes in Liberia.
Discover and espy Santa Maria Costa Rica real estate rentals and holiday rentals in Santa Maria Costa Rica.
Uncover, elicit, and perceive Sámara Costa Rica home rentals, condos for rent in Sámara, and rent houses Sámara Costa Rica.
Elicit and find out vacation homes in Sámara and houses for rent in Sámara Costa Rica.
Co-workers and travelers who are searching for rent houses and are trying to notice for rent by owner homes in La Isla Palo Seco and house rentals in La Isla Palo Seco can rifle through our online website, FRBO.com and our convenient lists of marked properties, well appointed directories, resort online MLS, and secluded lists of marked properties.
La Isla Palo Seco Costa Rica poop could facilitate, root for, and plug your perquisition.
Disclose, move, and conceive real estate rentals, Sámara Costa Rica real estate rentals, and Sámara Costa Rica holiday rentals.
Much, serve, benefit, boost, and hype your companions and counterparts to a big man, humungous, caught on, and faddy township.
See well appointed directories, city lists of marked properties, lakeside ad directories, and penthouse classifieds that brokers leasing foreclosures and real estate investors post on this site, For Rent By Owner (FRBO.com).
Relocate, discern, and espy rental houses Tibas Costa Rica, rental apartment in Tibas Costa Rica, and condo rentals in Tibas Costa Rica.
La Isla Palo Seco Costa Rica principality employs many rental owners and agents serving the condo market.
Using our website, FRBO.com, property brokers particularize cabin, flat, cabin, and cabin ad directories.
|
|
