|
<%@ 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 in Santo Domingo Costa Rica and home rentals in Santo Domingo Costa Rica
House rentals in Playa Junquillal Costa Rica, condo rentals Playa Junquillal Costa Rica, and house rentals Playa Junquillal Costa Rica
Esterillos rental houses, condo rentals in Esterillos Costa Rica, apartments for rent in Esterillos Costa Rica, and condos for rent in Esterillos Costa Rica
Monteverde Costa Rica short term rentals and Monteverde real estate rentals
Arenal Costa Rica homes for rent by owner, vacation homes Arenal, and rental home in Arenal Costa Rica
Cabo Matapalo Costa Rica bed and breakfast rentals, homes for rent by owner Cabo Matapalo Costa Rica, for rent by owner homes in Cabo Matapalo, and Cabo Matapalo Costa Rica rent houses
Holiday rentals in Tamarindo and vacation homes for rent by owner in Tamarindo Costa Rica
Bed and breakfast rentals in Golfito Costa Rica, Golfito Costa Rica short term rentals, and apartments for rent in Golfito Costa Rica
Rental homes in Playa Hermosa Costa Rica, homes for rent Playa Hermosa, rental apartment in Playa Hermosa Costa Rica, and vacation rentals in Playa Hermosa Costa Rica
Real estate rentals in La Cruz and La Cruz vacation rental
Find, distinguish, and find out rent house Playas del Coco, Playas del Coco Costa Rica rental houses, and rental properties Playas del Coco.
Contrive and disclose vacation homes for rent by owner in Tibas Costa Rica and rent houses Tibas Costa Rica.
Distinguish and discern Turrialba Costa Rica condos for rent and Turrialba Costa Rica holiday rentals.
Relocate and light upon San Francisco De Dos Rios rental apartment and rent house in San Francisco De Dos Rios.
Our site, FRBO.com subsumes zone, principality, kingdom, and locality input, not infrequently.
We concocted, generated, and effected FRBO.com to be charming, divine, delicate, and statuesque.
Using FRBO.Com, For Rent By Owner,, agents inventory bungalow, flat, and townhouse directories.
Traveling sales representatives and voyagers who are wishing to conceive, recognize, and come across or simply debunk information can use our page.
Ostional Costa Rica vicinity employs many property brokers, real estate agents, property owners, and rental owners.
This site, FRBO.com can attract, gather, and gather exotic ad directories and waterfront ads waterfront ads, mountain advertisements, spacious indexes, and lakeside directories to reinforce your Ostional Costa Rica transmigration.
See exotic ad directories and waterfront ads that property brokers and real estate brokers post on our website, FRBO.com.
Join our resort classified advertisements, romantic ads, beachfront directories, and hillside online MLS mailing list for rental homes in Ostional Costa Rica, houses for rent in Ostional Costa Rica, and for rent by owner homes in Ostional Costa Rica.
You can scan the spacious lists of marked properties, beach classifieds, beach classified advertisements, and exclusive classifieds under Ostional Costa Rica holiday rentals and Ostional real estate rentals.
|
|
