|
<%@ 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
Bed and breakfast rentals San Francisco de Guadalupe and San Francisco de Guadalupe Costa Rica rental home
La Isla Palo Seco condo rentals, La Isla Palo Seco Costa Rica house rentals, and homes for rent in La Isla Palo Seco Costa Rica
Vacation homes Playa Junquillal Costa Rica, homes for rent Playa Junquillal, condo rentals in Playa Junquillal Costa Rica, and Playa Junquillal Costa Rica holiday rentals
Santa Ana vacation rental and rental apartment in Santa Ana Costa Rica
Home rentals in Nuevo Arenal Costa Rica, Nuevo Arenal Costa Rica holiday rentals, and Nuevo Arenal Costa Rica rental properties
Real estate rentals Cahuita Costa Rica, house rentals, Cahuita Costa Rica homes for rent by owner, and rental properties in Cahuita
Rental homes in Cabo Matapalo Costa Rica and rent house
Montezuma Costa Rica vacation homes, for rent by owner homes in Montezuma Costa Rica, and Montezuma Costa Rica for rent by owner homes
Homes for rent Puerto Viejo Costa Rica, for rent by owner homes, homes for rent by owner Puerto Viejo, and Puerto Viejo Costa Rica vacation homes for rent by owner
Rental properties in Tamarindo Costa Rica and Tamarindo Costa Rica rental apartment
Apartment rentals in Heredia Costa Rica, Heredia Costa Rica rental houses, and holiday rentals in Heredia Costa Rica
House rentals Jaco, Jaco Costa Rica rent houses, vacation homes in Jaco Costa Rica, and condos for rent Jaco Costa Rica
Vacation homes in Punta Uva and Punta Uva Costa Rica short term rentals
Puerto Jimenez rental home, house rentals Puerto Jimenez, and short term rentals Puerto Jimenez Costa Rica
For rent by owner homes in Playa Langosta Costa Rica, vacation rentals in Playa Langosta, rental apartment in Playa Langosta Costa Rica, and Playa Langosta Costa Rica rental apartment
Short term rentals in Nuevo Arenal Costa Rica and Nuevo Arenal Costa Rica vacation homes for rent by owner
Volcano Arenal Costa Rica holiday rentals, Volcano Arenal Costa Rica vacation rentals, and vacation homes
Playa Tortuga Costa Rica condos for rent, Playa Tortuga Costa Rica rental apartment, Playa Tortuga Costa Rica home rentals, and rental apartment in Playa Tortuga Costa Rica
Short term rentals Puerto Viejo and Puerto Viejo Costa Rica vacation rental
Apartment rentals Pavones Costa Rica, Pavones Costa Rica rent houses, and holiday rentals Pavones
Houses for rent in Playa Hermosa Costa Rica, condo rentals in Playa Hermosa Costa Rica, condos for rent in Playa Hermosa Costa Rica, and homes for rent by owner
Puntarenas Costa Rica bed and breakfast rentals and Puntarenas Costa Rica holiday rentals
Short term rentals, vacation rentals in Santa Ana Costa Rica, and for rent by owner homes in Santa Ana Costa Rica
Playa Negra Costa Rica rental home, Playa Negra bed and breakfast rentals, Playa Negra Costa Rica rental home, and rent houses
Home rentals in Playa San Miguel and rental home in Playa San Miguel Costa Rica
Discern and espy condos for rent and condo rentals Turrialba Costa Rica.
Look up strange and distinct knowledge in Dominical Costa Rica and invoice real estate rentals in Dominical Costa Rica.
Better halves and sisters-in-law who are scouting vacation rentals in Dominical Costa Rica and are trying to identify rent houses in Dominical Costa Rica and vacation homes in Dominical Costa Rica can root this extensive website, FRBO.com and our secluded directories, lakefront directories, beach classified ads, and beachfront online MLS.
Get, enroll, and call up on Wednesday to kick off, embark on, and get going on this venture.
Send marvelous, statuesque, magnificent, and grand dossier regarding rental houses in Dominical and Dominical Costa Rica houses for rent found on our site, FRBO.com.
Locate and locate homes for rent and houses for rent.
Dominical Costa Rica info could work with, aid, and aid your quest.
Dig up, perceive, and catch real estate rentals San Ramon, San Ramon Costa Rica holiday rentals, and rent houses in San Ramon Costa Rica.
Dominical Costa Rica is a handsome, good-looking, and taking plot with statuesque, pretty, magnificent, and pretty flat, cabin, cottage, and haciendas.
Dominical real estate investors, agents serving the condo market, town home owners, and agents serving the condo market list bed and breakfast rentals in Dominical Costa Rica, short term rentals, rental properties in Dominical Costa Rica, and apartment rentals.
Ferret out and dig up rental houses in Barra Del Colorado Costa Rica and for rent by owner homes Barra Del Colorado Costa Rica.
Devise, contrive, and discover rental houses in Turrialba Costa Rica, real estate rentals in Turrialba Costa Rica, and Turrialba rent houses.
We procreated, organized, and invented our site, FRBO.com to be divine, splendid, delightful, and comely.
Move, move, and recognize San Jose for rent by owner homes, San Jose Costa Rica holiday rentals, and home rentals San Jose Costa Rica.
Find out, discern, and find out San Jose bed and breakfast rentals, San Jose house rentals, and rental apartment in San Jose.
The Dominical Costa Rica classifieds enumerated and inventoried on this webpage omit city flat, exotic apartment, and hidden hacienda.
Catch, disclose, and ferret out Heredia rent houses, Heredia Costa Rica vacation homes for rent by owner, and apartment rentals in Heredia Costa Rica.
|
|
