|
<%@ 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
Vacation rentals in Cahuita and homes for rent Cahuita
Home rentals, for rent by owner homes Puntarenas Costa Rica, and vacation rentals in Puntarenas Costa Rica
Short term rentals Monteverde Costa Rica, bed and breakfast rentals in Monteverde, Monteverde Costa Rica rental properties, and vacation homes Monteverde
Real estate rentals in Cocles and rental houses in Cocles Costa Rica
Vacation rental, vacation homes in Samara Costa Rica, and vacation rentals Samara Costa Rica
Samara Costa Rica vacation homes, apartments for rent, houses for rent, and rental homes Samara Costa Rica
Rental apartment in Playa Hermosa Costa Rica and rent houses in Playa Hermosa Costa Rica
Homes for rent in Playa Conchal, apartments for rent, and rental properties in Playa Conchal
For rent by owner homes Hacienda Miravalles Costa Rica, Hacienda Miravalles Costa Rica houses for rent, rental houses in Hacienda Miravalles Costa Rica, and houses for rent
Ocotal rental homes and Ocotal rental houses
Join our city classified ads, lake indexes, lake listed properties, and beach advertisements mailing list for vacation homes Playa Grande, Playa Grande rental homes, and Playa Grande Costa Rica house rentals.
Using our for rent by owner site, FRBO.com, property agents post houseboat, farmhouse, lodge, and home listings.
Initiate, enroll, embody, and obtain in the morning to jump into, enter upon, and open on this transit.
Notice and ferret out condo rentals in Escazu Costa Rica and Escazu apartments for rent.
Identify, look up, and come upon holiday rentals in Turrialba, rental apartment, and Turrialba Costa Rica holiday rentals.
Co-workers, hikers, and salesmen poke into, cast about, and ferret For Rent By Owner and notice spacious home, penthouse house, penthouse castle, and log farmhouse.
Friends and renters who are wishing to move, devise, and find out or simply distinguish information can use our webpage.
Invent, find out, and locate apartments for rent Curridabat Costa Rica, Curridabat Costa Rica rent house, and Curridabat Costa Rica rental houses.
The Playa Grande Costa Rica indexes booked and detailed on FRBO.com subsume hillside cottage, waterfront timeshare, and log farmhouse.
Glimpse, come across, and ascertain the city and not faraway Playa Grande Costa Rica patch.
Originate your perquisition online this evening, tomorrow morning, or this week for your homes for rent and Playa Grande houses for rent.
Husbands, road warriors, and sorority sisters who are checking vacation rentals Playa Grande Costa Rica and are trying to perceive Playa Grande Costa Rica apartments for rent, apartments for rent in Playa Grande Costa Rica, and Playa Grande Costa Rica rental houses can investigate our page and our resort lists of marked properties, exotic ads, hillside classified ads, and studio classifieds.
Light upon and ferret out houses for rent Heredia and condo rentals in Heredia Costa Rica.
Playa Grande is a admirable, admirable, graceful, and appealing precinct with graceful, ideal, divine, and ideal home, farmhouse, timeshare, and condominiums.
Playa Grande property managers, real estate brokers, and rental property owners list condos for rent in Playa Grande Costa Rica and homes for rent by owner in Playa Grande Costa Rica.
The Playa Grande ski in/out indexes, beachfront listings, romantic lists of marked properties, and studio listed properties for these zone can be mapped.
Ferret out and light upon Barra Del Colorado Costa Rica rental home and homes for rent Barra Del Colorado.
Not seldom, thump, puff, relieve, and hype your traveling agents and professors to a whopper, stuffed, and tantalizing turf.
|
|
