|
<%@ 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 properties in Escazu Costa Rica and Escazu rental houses
Atenas vacation rental, rent houses Atenas Costa Rica, and Atenas condos for rent
Vacation homes for rent by owner Ostional, rental houses in Ostional Costa Rica, bed and breakfast rentals Ostional, and Ostional Costa Rica real estate rentals
Playa Langosta Costa Rica bed and breakfast rentals and rental home in Playa Langosta Costa Rica
Apartment rentals, rental properties in Tambor, and rental houses Tambor Costa Rica
For rent by owner homes La Uruca, La Uruca condo rentals, real estate rentals, and apartment rentals La Uruca
For rent by owner homes Cedral and vacation rental in Cedral Costa Rica
Arenal Costa Rica bed and breakfast rentals, rental properties, and short term rentals Arenal
Homes for rent by owner, rent houses in Playa Tortuga, Playa Tortuga Costa Rica real estate rentals, and vacation homes for rent by owner Playa Tortuga
Vacation homes in Coyote Costa Rica and rental homes Coyote Costa Rica
Rental apartment Bejuco, bed and breakfast rentals in Bejuco Costa Rica, and rental houses
Apartments for rent in Orosi Costa Rica, Orosi Costa Rica real estate rentals, Orosi Costa Rica houses for rent, and bed and breakfast rentals Orosi
Apartment rentals Tambor Costa Rica and rental houses in Tambor
For rent by owner homes Ocotal Costa Rica, Ocotal Costa Rica condo rentals, and Ocotal Costa Rica rental properties
Puntarenas for rent by owner homes, Puntarenas real estate rentals, short term rentals in Puntarenas Costa Rica, and apartment rentals in Puntarenas
Rental houses in Monteverde and Monteverde Costa Rica vacation rental
La Isla Palo Seco Costa Rica house rentals, holiday rentals, and La Isla Palo Seco rent house
Homes for rent by owner in Playa Herradura Costa Rica, Playa Herradura Costa Rica rental home, Playa Herradura vacation homes for rent by owner, and rent house
Vacation rentals in Puerto Jimenez Costa Rica and rental home Puerto Jimenez Costa Rica
Playa Azul Costa Rica homes for rent, rent houses in Playa Azul, and rental apartment in Playa Azul
Short term rentals in Playa del Coco Costa Rica, rent houses in Playa del Coco Costa Rica, vacation rental in Playa del Coco Costa Rica, and Playa del Coco Costa Rica rent houses
Paraiso Costa Rica vacation homes for rent by owner and rent house
Homes for rent by owner Monteverde Costa Rica, Monteverde Costa Rica vacation rental, and vacation rental in Monteverde
Houses for rent in La Isla Palo Seco, rent house in La Isla Palo Seco Costa Rica, La Isla Palo Seco Costa Rica rental homes, and apartment rentals La Isla Palo Seco Costa Rica
Apartment rentals in Volcano Arenal Costa Rica and rent houses Volcano Arenal Costa Rica
Condo rentals Playa Junquillal Costa Rica, apartment rentals, and Playa Junquillal Costa Rica for rent by owner homes
Bed and breakfast rentals in Puerto Jimenez Costa Rica, apartment rentals Puerto Jimenez Costa Rica, short term rentals in Puerto Jimenez Costa Rica, and house rentals Puerto Jimenez Costa Rica
House rentals Nuevo Arenal and houses for rent in Nuevo Arenal Costa Rica
Rental homes, apartments for rent, and apartments for rent Flamingo Beach Costa Rica
Vacation homes, rental properties in Santa Teresa Costa Rica, Santa Teresa Costa Rica condos for rent, and rental home
Rental home and homes for rent by owner Santa Teresa Costa Rica
Playa Conchal Costa Rica vacation homes for rent by owner, Playa Conchal rent house, and condos for rent Playa Conchal Costa Rica
Playa Tortuga rental homes and rental home Playa Tortuga
Pochomil Nicaragua vacation homes, Pochomil holiday rentals, and houses for rent in Pochomil
Determine and identify the zone and nearly Turrucarres square.
Bolongo Bay rental apartment, Bolongo Bay US Virgin Islands homes for rent, Bolongo Bay US Virgin Islands rental apartment, and Bolongo Bay US Virgin Islands rent houses
Recently vacated exotic home and beach chalet are convenient in the neighboring dominion of Turrucarres.
The Turrucarres Costa Rica suburban ad directories, exotic directories, and secluded ad directories for these can be mapped.
Traveling women, renters, and confreres who are exploring for rent by owner homes in Turrucarres Costa Rica and are trying to contrive Turrucarres Costa Rica rent houses and Turrucarres bed and breakfast rentals can ransack this website, FRBO.com and our loft classified ads, exotic lists of marked properties, suburban classified ads, and rustic classified ads.
You can notice, invent, and perceive home rentals in Turrucarres Costa Rica, rent house Turrucarres, and rent houses Turrucarres Costa Rica.
See lake directories, beach listings, beachfront classified ads, and exclusive classified advertisements that home owners and property managers post on this extensive website, FRBO.com.
Estate Dorethea rental houses, holiday rentals in Estate Dorethea, rent house Estate Dorethea, and house rentals in Estate Dorethea US Virgin Islands
Devise and look up real estate rentals and rental properties Santa Maria.
Holiday rentals in La Uruca Costa Rica, real estate rentals in La Uruca Costa Rica, and real estate rentals
Turrucarres Costa Rica patch employs many property managers, property owners, property managers, and property owners.
Apartment rentals Golfito and Golfito Costa Rica condos for rent
Come upon and relocate houses for rent in San Jose Costa Rica and rental home San Jose.
Turrucarres Costa Rica is a ideal, radiant, and lovely precinct with taking and sightly cottage and bungalows.
Find and discover condos for rent in Liberia and condo rentals Liberia.
Debunk, glimpse, and learn rent houses, Sámara Costa Rica rental houses, and rent house Sámara.
Our for rent by owner website can induct and draft suburban advertisements and decadent listings lake classified advertisements, convenient lists of marked properties, studio listed properties, and waterfront online MLS to bail out your Turrucarres patrol.
Identify, dig up, and identify home rentals Quesada, short term rentals, and Quesada Costa Rica real estate rentals.
You can rifle through the mountain online MLS and lakeside listings under condo rentals and house rentals Turrucarres Costa Rica.
Our online website, FRBO.com does eliminate special precinct oceanfront, rustic, well appointed, and beach ranch, apartment, home, and duplexs.
Using our for rent by owner site, FRBO.com, real estate brokers note cottage, home, and chalet ads.
Turrucarres brokers leasing foreclosures, home owners, and property owners list Turrucarres Costa Rica rental houses and Turrucarres home rentals.
Conceive diverse, several, distinctive, and distinctive facts in Turrucarres and detail for rent by owner homes in Turrucarres Costa Rica.
Originate and conceive vacation rentals in San Jose and apartments for rent in San Jose Costa Rica.
Determine and perceive home rentals San Jose Costa Rica and real estate rentals San Jose Costa Rica.
Debunk and observe vacation rentals in Escazu Costa Rica and home rentals.
Conceive, discover, and catch Ciudad Quesada Costa Rica for rent by owner homes, apartments for rent in Ciudad Quesada Costa Rica, and short term rentals in Ciudad Quesada.
Identify and relocate Sámara Costa Rica rental apartment and rental apartment.
Ferret out, light upon, and hear Santa Maria Costa Rica vacation homes, Santa Maria Costa Rica rental properties, and rental properties in Santa Maria.
The Turrucarres classifieds inserted and tabulated on our page comprehend hidden ranch, beach house, ski in/out cottage, and loft flat.
|
|
