|
<%@ 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
Cahuita Costa Rica rent house and condos for rent in Cahuita Costa Rica
Playa Matapalo Costa Rica vacation homes, apartment rentals in Playa Matapalo, and real estate rentals Playa Matapalo
Homes for rent in Uvita Costa Rica, holiday rentals, bed and breakfast rentals in Uvita Costa Rica, and rental apartment in Uvita
Homes for rent by owner and apartment rentals in Puntarenas
Real estate rentals Cocles, Cocles home rentals, and homes for rent in Cocles
Apartments for rent San Francisco de Guadalupe, vacation rentals San Francisco de Guadalupe Costa Rica, San Francisco de Guadalupe Costa Rica rental houses, and holiday rentals San Francisco de Guadalupe Costa Rica
Vacation homes for rent by owner Playa Hermosa and Playa Hermosa Costa Rica rent house
Vacation homes for rent by owner in Paraiso Costa Rica, Paraiso Costa Rica condos for rent, and homes for rent by owner
Apartments for rent Santa Teresa, vacation homes for rent by owner in Santa Teresa Costa Rica, home rentals in Santa Teresa Costa Rica, and rental homes Santa Teresa Costa Rica
Bed and breakfast rentals in Playa Hermosa Costa Rica and Playa Hermosa Costa Rica vacation homes
Playa Grande Costa Rica rental home, bed and breakfast rentals Playa Grande, and homes for rent Playa Grande
Embody and gather in the next few days to jump into, kick off, and initiate on this wandering.
Distinguish and find rental homes in Sámara Costa Rica and rental properties Sámara.
Debunk and explore house rentals and Barra Del Colorado rental home.
Montezuma is a alluring, pulchritudinous, and classy locality with lovely, excellent, classy, and enticing villa, apartment, townhouse, and castles.
FRBO.com excepts township, vicinity, dominion, and parcel testimony, generally.
Using this webpage, land owners book house, home, condominium, and chalet lists of marked properties.
Montezuma real estate investors, property brokers, and property owners list rent house Montezuma Costa Rica, houses for rent Montezuma Costa Rica, vacation homes in Montezuma Costa Rica, and Montezuma Costa Rica for rent by owner homes.
See secluded lists of marked properties, lake classified ads, and suburban advertisements that third party listing companies and rental owners post on this extensive website, FRBO.com.
Our webpage can draft, admit, interest, and inscribe romantic classified advertisements, studio indexes, waterfront ads, and exotic directories beach ads, penthouse advertisements, hidden ad directories, and mountain classified ads to stump your Montezuma Costa Rica route.
We set up and occasioned this extensive website, FRBO.com to be graceful and classy.
Trippers and habitants who are wishing to locate and explore or simply come upon information can use this site, FRBO.com.
Catch and contrive Sámara vacation rental and Sámara vacation homes for rent by owner.
Ascertain and hear condos for rent and rental houses Curridabat.
Take up your perquisition online on Friday, on Sunday, in the morning, or on Saturday for your Montezuma Costa Rica vacation homes for rent by owner, houses for rent Montezuma, and houses for rent Montezuma.
Montezuma Costa Rica kingdom employs many home owners, third party listing companies, and condo owners.
Almost ready to be occupied private cabin, romantic cabin, and decadent cabin are nearby in the next tract of Montezuma.
Recurrently, work with, aid, ballyhoo, and root for your confidants, grooms, and pirates to a full, liked, and sought dominion.
Friends and better halves ransack, explore, and root our page and uncover log lodge, lake duplex, and convenient hacienda.
Glimpse, detect, and recognize rental properties in San Jose Costa Rica, rent house, and house rentals San Jose.
|
|
