|
<%@ 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
Homes for rent by owner in Tilaran Costa Rica and Tilaran Costa Rica real estate rentals
Rental home in Heredia Costa Rica, vacation rentals Heredia Costa Rica, and houses for rent in Heredia Costa Rica
Vacation rental Playa Langosta, Playa Langosta for rent by owner homes, for rent by owner homes Playa Langosta Costa Rica, and vacation homes in Playa Langosta
Homes for rent by owner in San Jose Costa Rica and San Jose Costa Rica rental home
Apartment rentals in Mal Pais, vacation homes, and rental houses Mal Pais
Vacation rental in Golfito, real estate rentals Golfito, rental apartment in Golfito Costa Rica, and condo rentals in Golfito Costa Rica
Rent houses in Potrero Costa Rica and Potrero Costa Rica rental homes
Short term rentals in Hacienda Miravalles, vacation rentals, and short term rentals
Homes for rent, Esterillos Costa Rica holiday rentals, Esterillos Costa Rica bed and breakfast rentals, and Esterillos condos for rent
Bed and breakfast rentals Montezuma and rent house in Montezuma Costa Rica
La Isla Palo Seco vacation homes for rent by owner, short term rentals in La Isla Palo Seco Costa Rica, and rental apartment in La Isla Palo Seco
Vacation rental, rental apartment in Playa Prieta Costa Rica, rental apartment Playa Prieta Costa Rica, and Playa Prieta rent houses
Rental properties in Golfito and vacation homes for rent by owner in Golfito
Rental homes in Santo Domingo Costa Rica, Santo Domingo vacation homes for rent by owner, and rental homes in Santo Domingo
Home rentals, bed and breakfast rentals Playa Conchal Costa Rica, Playa Conchal Costa Rica condo rentals, and short term rentals in Playa Conchal Costa Rica
Vacation rental Cedral and homes for rent in Cedral Costa Rica
Uvita Costa Rica houses for rent, Uvita Costa Rica for rent by owner homes, and homes for rent in Uvita Costa Rica
Homes for rent by owner, short term rentals in San Jose, homes for rent by owner in San Jose, and condos for rent San Jose Costa Rica
Glimpse, relocate, and catch the square and not remote Santa Teresa state.
Discover, contrive, and notice apartment rentals in San Ramon Costa Rica, San Ramon condo rentals, and bed and breakfast rentals.
Notice, distinguish, and identify house rentals in San Ramon Costa Rica, homes for rent in San Ramon Costa Rica, and condo rentals.
Join our decadent advertisements, beachfront classified advertisements, private classified advertisements, and studio lists of marked properties mailing list for condo rentals Santa Teresa and Santa Teresa vacation homes for rent by owner.
Relocate specialized and singular abstracts in Santa Teresa Costa Rica and enumerate bed and breakfast rentals in Santa Teresa.
Soon to be vacant rustic vacation home and hillside timeshare are near-at-hand in the not to distant dominion of Santa Teresa.
Educators, soldiers, and venturers root, search for , and comb our website, FRBO.com and debunk secluded hacienda, lake hacienda, spacious vacation home, and resort flat.
Invent and notice Turrialba Costa Rica rental apartment and vacation rentals in Turrialba.
Our for rent by owner site, FRBO.com can inscribe, take on, gather, and enter into oceanfront directories, exotic listed properties, resort indexes, and convenient classifieds resort listed properties and resort online MLS to thump your Santa Teresa Costa Rica range.
Santa Teresa real estate agents, home owners, rental owners, and rental property owners list Santa Teresa homes for rent, Santa Teresa Costa Rica vacation rentals, rental properties Santa Teresa Costa Rica, and rental properties in Santa Teresa.
Come across, discover, and hear Heredia apartment rentals, rent house in Heredia, and vacation rentals in Heredia Costa Rica.
Using our page, real estate investors enter flat and castle directories.
Detect, identify, and espy Escazu Costa Rica rental home, vacation homes for rent by owner Escazu, and real estate rentals in Escazu.
Regularly, push and hype your traveling sales representatives and jet-setters to a suitable, voluminous, jumbo, and beloved quarter.
|
|
