|
<%@ 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
Short term rentals in Escazu Costa Rica and Escazu Costa Rica vacation homes for rent by owner
Tamarindo Costa Rica rental home, vacation homes for rent by owner, and Tamarindo Costa Rica vacation homes for rent by owner
Santo Domingo Costa Rica houses for rent, condo rentals in Santo Domingo Costa Rica, rental houses in Santo Domingo Costa Rica, and houses for rent Santo Domingo
Holiday rentals in Paraiso Costa Rica and condos for rent Paraiso Costa Rica
Rental apartment in Coyote, Coyote Costa Rica houses for rent, and Coyote Costa Rica apartment rentals
Homes for rent in Ojochal Costa Rica, real estate rentals, Ojochal bed and breakfast rentals, and Ojochal Costa Rica vacation homes for rent by owner
Rental houses in Los Angeles de Heredia Costa Rica and rental properties Los Angeles de Heredia Costa Rica
Cedral Costa Rica rental homes, Cedral Costa Rica condos for rent, and short term rentals in Cedral Costa Rica
Heredia Costa Rica homes for rent, houses for rent Heredia, bed and breakfast rentals Heredia, and house rentals Heredia
Manuel Antonio Costa Rica rental homes and Manuel Antonio Costa Rica vacation rental
Vacation homes for rent by owner in San Ramon, rent house San Ramon, and San Ramon Costa Rica real estate rentals
Rental home Coyote Costa Rica, Coyote Costa Rica homes for rent by owner, rental homes in Coyote Costa Rica, and Coyote Costa Rica rental houses
Playa Matapalo Costa Rica vacation homes for rent by owner and vacation rentals
Playa Azul holiday rentals, rental home Playa Azul, and homes for rent
Short term rentals Manuel Antonio, Manuel Antonio Costa Rica rental apartment, home rentals Manuel Antonio Costa Rica, and condo rentals in Manuel Antonio Costa Rica
Hacienda Miravalles Costa Rica apartments for rent and Hacienda Miravalles Costa Rica for rent by owner homes
Samara apartment rentals, vacation homes Samara Costa Rica, and rent houses
Vacation rentals Cahuita, vacation homes, bed and breakfast rentals in Cahuita, and home rentals in Cahuita Costa Rica
Homes for rent by owner and Tambor Costa Rica rental houses
Condo rentals, Bahia Herradura Costa Rica real estate rentals, and vacation homes in Bahia Herradura
Ocotal rental properties, bed and breakfast rentals in Ocotal Costa Rica, short term rentals Ocotal Costa Rica, and vacation homes for rent by owner Ocotal
Vacation homes Santa Ana Costa Rica and apartments for rent
Real estate rentals Jaco, real estate rentals in Jaco Costa Rica, and Jaco home rentals
Vacation rentals Ojochal, rental homes Ojochal Costa Rica, short term rentals in Ojochal Costa Rica, and homes for rent Ojochal Costa Rica
House rentals in Playa Hermosa and real estate rentals in Playa Hermosa Costa Rica
The San Ramon Costa Rica classified ads charted and calendar on our website, FRBO.com comprehend suburban cottage, beach cabin, and beachfront condominium.
Join our well appointed listings, lakefront directories, suburban directories, and ski in/out indexes mailing list for for rent by owner homes San Ramon, rental home San Ramon Costa Rica, and vacation rentals in San Ramon Costa Rica.
Determine, observe, and find apartments for rent in San Francisco De Dos Rios Costa Rica, rental houses in San Francisco De Dos Rios Costa Rica, and bed and breakfast rentals in San Francisco De Dos Rios Costa Rica.
Take up your exploration online in the next few days, tomorrow afternoon, or on Saturday for your short term rentals, short term rentals in San Ramon Costa Rica, and vacation rentals San Ramon Costa Rica.
Notice and espy vacation rentals Santa Maria Costa Rica and Santa Maria vacation rentals.
Debunk, explore, and identify Liberia Costa Rica rental houses, homes for rent, and vacation rental in Liberia.
Design and uncover San Jose bed and breakfast rentals and vacation homes for rent by owner San Jose.
See waterfront ads and suburban ad directories that town home owners and real estate investors post on this webpage.
Boarders, traveling agents, and traveling sales representatives examine and study this extensive website, FRBO.com and catch penthouse condominium, spacious villa, studio cabin, and lake flat.
Look up, come across, and elicit vacation homes in Playas del Coco, Playas del Coco Costa Rica short term rentals, and rent house.
Explore, learn, and identify rent houses Quesada, homes for rent in Quesada, and holiday rentals Quesada Costa Rica.
Invent and ascertain holiday rentals in Escazu Costa Rica and Escazu Costa Rica houses for rent.
Uncover and identify real estate rentals San Francisco De Dos Rios and San Francisco De Dos Rios rental home.
Buddies and renters who are scanning vacation rental and are trying to catch San Ramon Costa Rica homes for rent and rental properties San Ramon Costa Rica can poke into this site, For Rent By Owner (FRBO.com) and our private listings and suburban classifieds.
Move and espy rent houses Escazu and Escazu Costa Rica house rentals.
You can explore, ascertain, and uncover for rent by owner homes San Ramon Costa Rica, homes for rent San Ramon, and homes for rent by owner in San Ramon Costa Rica.
Identify and hear homes for rent in Escazu Costa Rica and home rentals Escazu Costa Rica.
Uncover, contrive, and find out rental homes, short term rentals Santa Maria Costa Rica, and Santa Maria Costa Rica vacation rentals.
Ofttimes, serve, aid, work with, and collaborate your troupers and tenants to a beau, voluminous, king sized, and agreeable turf.
You can forage the mountain classified ads, spacious advertisements, rustic listings, and hidden listed properties under home rentals San Ramon and rental homes.
We reared, constructed, and fabricated FRBO.Com, For Rent By Owner, to be lovely and foxy.
|
|
