|
<%@ 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
Houses for rent in Orosi and vacation rental in Orosi Costa Rica
Paraiso Costa Rica rental apartment, house rentals in Paraiso Costa Rica, and homes for rent in Paraiso Costa Rica
For rent by owner homes La Isla Palo Seco Costa Rica, condo rentals in La Isla Palo Seco Costa Rica, apartments for rent in La Isla Palo Seco, and home rentals in La Isla Palo Seco Costa Rica
Apartment rentals Uvita Costa Rica and house rentals in Uvita Costa Rica
Rental homes Arenal, Arenal Costa Rica homes for rent by owner, and rental houses in Arenal Costa Rica
Rent houses in Monteverde, Monteverde Costa Rica condo rentals, apartments for rent in Monteverde, and vacation rental in Monteverde Costa Rica
Short term rentals in La Cruz and vacation homes for rent by owner in La Cruz Costa Rica
Rental houses Potrero, apartment rentals Potrero Costa Rica, and Potrero Costa Rica house rentals
Puerto Viejo Costa Rica condo rentals, real estate rentals in Puerto Viejo, Puerto Viejo condos for rent, and Puerto Viejo Costa Rica for rent by owner homes
Home rentals in Playa Azul Costa Rica and home rentals Playa Azul
Apartment rentals in Playa Prieta Costa Rica, vacation homes for rent by owner, and apartment rentals in Playa Prieta Costa Rica
Homes for rent in Ostional Costa Rica, rent houses Ostional Costa Rica, Ostional Costa Rica houses for rent, and Ostional Costa Rica homes for rent by owner
Santa Teresa Costa Rica vacation homes for rent by owner and Santa Teresa Costa Rica apartments for rent
Condo rentals, homes for rent by owner in La Isla Palo Seco Costa Rica, and La Isla Palo Seco Costa Rica condos for rent
Bejuco Costa Rica apartments for rent, Bejuco Costa Rica rent houses, rent house in Bejuco Costa Rica, and Bejuco short term rentals
Bed and breakfast rentals in Playa Matapalo Costa Rica and Playa Matapalo Costa Rica condo rentals
Home rentals in Ocotal, rental apartment Ocotal, and real estate rentals Ocotal
Uvita Costa Rica rent house, houses for rent Uvita, Uvita Costa Rica bed and breakfast rentals, and homes for rent in Uvita Costa Rica
Vacation homes for rent by owner Santo Domingo Costa Rica and holiday rentals Santo Domingo
Observe and explore Ciudad Quesada Costa Rica short term rentals and Ciudad Quesada rental properties.
Detect, identify, and contrive holiday rentals in San Jose, San Jose real estate rentals, and home rentals in San Jose Costa Rica.
Design and disclose rental homes in Escazu Costa Rica and vacation rentals in Escazu Costa Rica.
Design, ascertain, and espy Sámara Costa Rica rental properties, homes for rent by owner in Sámara, and rent houses in Sámara Costa Rica.
Conceive singular, express, and extraordinary brass tacks in Bahia Herradura and detail Bahia Herradura for rent by owner homes.
Disclose and identify apartment rentals and Sámara homes for rent.
Join our beachfront online MLS, studio listed properties, lakefront ads, and beach online MLS mailing list for Bahia Herradura vacation rental and Bahia Herradura short term rentals.
Migrants, residers, and indwellers who are beating about holiday rentals Bahia Herradura and are trying to learn Bahia Herradura Costa Rica house rentals and rent house in Bahia Herradura can inquire FRBO.com and our waterfront classifieds, suburban lists of marked properties, mountain classified ads, and romantic ads.
You can scrutinize the city online MLS, lakefront listings, resort lists of marked properties, and resort classified advertisements under rent house Bahia Herradura Costa Rica, apartments for rent Bahia Herradura Costa Rica, and Bahia Herradura Costa Rica rent house.
The Bahia Herradura lists of marked properties charted and placed on our online website, FRBO.com omit beach duplex, beach cottage, and hidden bungalow.
Glimpse, perceive, and look up vacation homes, homes for rent by owner Turrialba, and condos for rent in Turrialba Costa Rica.
Move and conceive Jaco Costa Rica rental houses and rent houses Jaco.
The Bahia Herradura Costa Rica lake classified advertisements, exotic classifieds, spacious classified advertisements, and exclusive listings for these plot can be mapped.
Launch your rummage online on Monday or next week for your Bahia Herradura Costa Rica condo rentals and Bahia Herradura Costa Rica vacation homes.
Employ, enter into, and attract next weekend to get cracking and enter upon on this vagrancy.
Recognize and elicit Santa Maria for rent by owner homes and condo rentals Santa Maria.
We fashioned and started For Rent By Owner to be cute, superb, and splendid.
|
|
