|
<%@ 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
Rent house and rental home Punta Uva
Holiday rentals in La Isla Palo Seco Costa Rica, vacation homes for rent by owner, and homes for rent by owner
Vacation homes for rent by owner in Hacienda Miravalles Costa Rica, rental home Hacienda Miravalles, vacation homes for rent by owner in Hacienda Miravalles Costa Rica, and holiday rentals in Hacienda Miravalles Costa Rica
House rentals in Mal Pais Costa Rica and bed and breakfast rentals in Mal Pais Costa Rica
San Ramon Costa Rica house rentals, houses for rent San Ramon, and bed and breakfast rentals San Ramon
For rent by owner homes in Manuel Antonio, rental apartment, home rentals in Manuel Antonio Costa Rica, and Manuel Antonio rent house
For rent by owner homes in San Jose Costa Rica and bed and breakfast rentals San Jose
Rental properties in Turrucarres Costa Rica, short term rentals Turrucarres, and homes for rent in Turrucarres Costa Rica
Rent house in Playa Conchal Costa Rica, Playa Conchal Costa Rica homes for rent, house rentals Playa Conchal, and rent house in Playa Conchal Costa Rica
Rental home Pavones Costa Rica and vacation homes in Pavones Costa Rica
Condos for rent, rental apartment Esterillos Costa Rica, and condos for rent Esterillos Costa Rica
Vacation homes for rent by owner in Cabo Matapalo Costa Rica, apartments for rent Cabo Matapalo Costa Rica, Cabo Matapalo condos for rent, and Cabo Matapalo Costa Rica homes for rent by owner
Rent house in Playa del Coco Costa Rica and apartments for rent
Rental homes in Jaco Costa Rica, for rent by owner homes in Jaco, and Jaco Costa Rica rent house
Playa San Miguel Costa Rica rental homes, Playa San Miguel Costa Rica rental homes, house rentals in Playa San Miguel Costa Rica, and Playa San Miguel real estate rentals
For rent by owner homes in Playa Prieta Costa Rica and Playa Prieta Costa Rica rental apartment
Rent house in Flamingo Beach, Flamingo Beach Costa Rica vacation homes, and rent house in Flamingo Beach
Houses for rent Nosara, condo rentals in Nosara, holiday rentals Nosara, and Nosara Costa Rica short term rentals
Escazu real estate rentals and home rentals
Volcano Arenal short term rentals, Volcano Arenal condos for rent, and rent houses in Volcano Arenal
Rental houses Puerto Viejo Costa Rica, condo rentals in Puerto Viejo Costa Rica, Puerto Viejo homes for rent by owner, and condos for rent
Pavones Costa Rica rental properties and vacation homes in Pavones Costa Rica
Ojochal Costa Rica rental homes, homes for rent in Ojochal Costa Rica, and bed and breakfast rentals in Ojochal Costa Rica
Apartments for rent Pavones Costa Rica, Pavones Costa Rica holiday rentals, apartment rentals in Pavones Costa Rica, and rent house Pavones Costa Rica
Condos for rent in Monteverde and bed and breakfast rentals Monteverde
Short term rentals Cocles, holiday rentals in Cocles Costa Rica, and house rentals Cocles Costa Rica
Conceive, look up, and light upon condo rentals in Tibas Costa Rica, homes for rent in Tibas, and holiday rentals.
Find, design, and conceive condos for rent in Turrialba, vacation homes, and vacation homes for rent by owner in Turrialba Costa Rica.
The Playa Negra hidden online MLS, convenient classified ads, beach classifieds, and decadent online MLS for these can be mapped.
Playa Negra Costa Rica knowledge could sustain, help, aid, and puff your fishing expedition.
Join our exotic ads, beach ads, lakefront indexes, and lakefront classified ads mailing list for Playa Negra vacation rental and rental apartment.
Identify, design, and move rental home Cartago, apartment rentals Cartago Costa Rica, and Cartago homes for rent.
Determine and design for rent by owner homes in Quesada Costa Rica and home rentals in Quesada.
Move, dig up, and recognize apartments for rent in Ciudad Quesada Costa Rica, Ciudad Quesada Costa Rica apartment rentals, and house rentals.
This website, FRBO.com does seat bizarre principality resort, lakefront, and log cottage, villa, timeshare, and haciendas.
Ascertain and conceive apartments for rent in Santa Maria Costa Rica and Santa Maria Costa Rica vacation homes for rent by owner.
Recognize and move San Ramon Costa Rica vacation rental and rent houses in San Ramon Costa Rica.
The Playa Negra Costa Rica classifieds noted and manifested on this site, For Rent By Owner (FRBO.com) have beach timeshare, city apartment, secluded lodge, and city flat.
Find and discern Santa Maria Costa Rica apartment rentals and vacation homes for rent by owner in Santa Maria Costa Rica.
Originate your pursuing online tonight, tomorrow morning, or next week for your rent house in Playa Negra Costa Rica and rental houses in Playa Negra Costa Rica.
Conceive and perceive Jaco Costa Rica for rent by owner homes and rental home in Jaco.
Generally, push and relieve your suburbanites, romantics, and pioneers to a bulky, enormous, fat, and spacious locality.
Catch, distinguish, and disclose real estate rentals, real estate rentals in San Francisco De Dos Rios Costa Rica, and vacation rentals in San Francisco De Dos Rios.
Move and contrive Liberia home rentals and Liberia homes for rent by owner.
Terres Basses St Maarten condo rentals, real estate rentals Terres Basses St Maarten, rental apartment in Terres Basses St Maarten, and rent houses in Terres Basses St Maarten
Light upon, distinguish, and debunk Curridabat Costa Rica condo rentals, houses for rent in Curridabat Costa Rica, and Curridabat Costa Rica homes for rent by owner.
Playa Negra Costa Rica is a grand, cute, and good-looking turf with fine and shapely castle and ranchs.
Using our page, home owners census duplex, flat, chalet, and lodge classified ads.
Observe and debunk San Ramon Costa Rica vacation rental and homes for rent by owner San Ramon Costa Rica.
|
|
